package cn.ikun.xk.JDBC;


import java.sql.*;
import java.util.Scanner;

public class AppLogin {
    public static void main(String[] args) throws Exception{
        Scanner scanner = new Scanner(System.in);

        System.out.println("请输入账号");
        String username = scanner.nextLine();

        System.out.println("请输入密码");
        String password = scanner.nextLine();

        login(username, password);

    }
    public static void login(String n, String p) throws Exception{
        System.out.println("输入的账号是：" + n);
        System.out.println("输入的密码是：" + p);
        String sql = "SELECT id FROM `jk_user` WHERE username = '"
                + n +
                "' AND `password` = MD5('" + p + "')";
        //System.out.println("组成的sql语句是：" + sql);
        
        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/baga?useSSL=false";
        String username = "root";
        String password = "xk20011216";
        Connection connection = DriverManager.getConnection(url, username, password);
        Statement statement = connection.createStatement();
        ResultSet set = statement.executeQuery(sql);
        if (set.next()) {
            System.out.println("登录成功！");
        } else {
            System.out.println("登录失败！");
        }




    }
    public static void loginPlus(String n, String p) throws Exception {
        System.out.println("输入的账号是：" + n);
        System.out.println("输入的密码是：" + p);
        String sql = "SELECT id FROM `jk_user` WHERE username = ?  AND `password` = MD5(?)";

        Class.forName("com.mysql.jdbc.Driver");
        String url = "jdbc:mysql://localhost:3306/baga?useSSL=false";
        String username = "root";
        String password = "xk20011216";
        Connection connection = DriverManager.getConnection(url, username, password);

        // 使用 connection 的 prepareStatement 方法创建一个 PreparedStatement 对象
        PreparedStatement ps = connection.prepareStatement(sql);
        // the first parameter is 1, the second is 2, ...
        ps.setString(1, n);
        ps.setString(2, p);
        ResultSet set = ps.executeQuery();

        if (set.next()) {
            System.out.println("登录成功！");
        } else {
            System.out.println("登录失败");
        }
    }

}
